Exercise: Split Columns

In the following exercise, you'll download a data set of American League baseball players and salaries from 2003, and split the Player name column into two columns for Last and First names.

As you work with larger data sets, its can be helpful to "freeze" the header row or far left column as you scroll through data. To do this, use the View->Freeze Panes operation in Excel or View->Freeze in Google Sheets to select the rows or columns you want to always be visible.

Task List:

Download the ALbb_salaries_2003.csv file (bottom of page) and open it in your spreadsheet application

Insert an empty column to the right of the Player column

Split the Player column into two columns at the comma named Last and First

Quiz: Split Column (see below)

QUIZ QUESTION::

Match the value to the address in your spreadsheet.

ANSWER CHOICES:

C264

A277

B215

D373

E17

Address	Value
Magglio
[empty cell]
May
May, Darrell
Minnesota Twins
Detroit Tigers
Pitcher
Shortstop
9,000,000
22,000,000

SOLUTION:

Address	Value
Magglio	C264
May	B215
Detroit Tigers	A277
Pitcher	E17
22,000,000	D373